package com.linktel.productionLine.dao;

import com.linktel.productionLine.entity.WorksheetYieldInfo;
import com.linktel.productionLine.entity.dto.worksheetYieldInfo.WsSerialDTO;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author Linktel
* @description 针对表【worksheet_yield_info(工单良率信息表)】的数据库操作Mapper
* @createDate 2023-09-27 09:18:04
* @Entity generator.entity.WorksheetYieldInfo
*/
public interface WorksheetYieldInfoDao {

    int deleteByPrimaryKey(Long id);

    int insert(WorksheetYieldInfo record);

    int insertSelective(WorksheetYieldInfo record);

    WorksheetYieldInfo selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(WorksheetYieldInfo record);

    int updateByPrimaryKey(WorksheetYieldInfo record);

    Long getWorkSheetIdByNumber(String wsSerialNumber);

    List<String> listProductCode();

    List<WsSerialDTO> listWsSerialNumber(@Param("productCode") String productCode);

    String getProductCode(String wsSerialNumber);
}
